SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
CREATE TABLE [dbo].[LogEntrys]( 
[Application] [nvarchar](250) NOT NULL,
[Computer] [nvarchar](30) NULL,
[Exception] [ntext] NULL,
[Message] [ntext] NULL,
[LogLevel] [int] NULL,
[UserName] [nvarchar](20) NULL,
[Id] [int] IDENTITY(1,1) NOT NULL,
[CreateDate] [datetime] NOT NULL,
[UpdateDate] [datetime] NOT NULL,
[CreateUser] [nvarchar](20) NOT NULL,
[UpdateUser] [nvarchar](20) NOT NULL,
[UpdateComment] [nvarchar](150) NULL,
[Version] [int] NOT NULL,
[IsActive] [bit] NOT NULL,
 CONSTRAINT [PK_LogEntrys] PRIMARY KEY CLUSTERED 
( [Id] ASC
 )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
